Căutare

Queries: 827, Total time: 476.221 ms [By time] [By id] [By file]

1 (0.066)

SELECT data
FROM `oc_session`
WHERE session_id = 'cbaecdcf07245107f48ebaf842'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.103)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:428

3 (220.192)

CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+crap' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737

4 (0.922)

SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561

5 (38.165)

SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 360, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

6 (0.727)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '112083' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

7 (0.249)

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 = '112083' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

8 (0.246)

SELECT a.attribute_id, a.arata, 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 = '112083' AND a.attribute_group_id = '13' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

9 (0.152)

SELECT *
FROM oc_product_image
WHERE product_id = '112083'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

10 (0.597)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '112024' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

11 (0.241)

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 = '112024' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

12 (0.218)

SELECT a.attribute_id, a.arata, 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 = '112024' AND a.attribute_group_id = '12' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

13 (0.105)

SELECT *
FROM oc_product_image
WHERE product_id = '112024'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

14 (0.600)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '107929' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

15 (0.152)

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 = '107929' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

16 (0.134)

SELECT a.attribute_id, a.arata, 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 = '107929' AND a.attribute_group_id = '37' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

17 (0.076)

SELECT *
FROM oc_product_image
WHERE product_id = '107929'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

18 (0.614)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '100346' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

19 (0.188)

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 = '100346' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

20 (0.138)

SELECT a.attribute_id, a.arata, 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 = '100346' AND a.attribute_group_id = '37' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

21 (0.072)

SELECT *
FROM oc_product_image
WHERE product_id = '100346'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

22 (0.602)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '101139' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

23 (0.183)

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 = '101139' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

24 (0.128)

SELECT a.attribute_id, a.arata, 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 = '101139' AND a.attribute_group_id = '17' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

25 (0.067)

SELECT *
FROM oc_product_image
WHERE product_id = '101139'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

26 (0.549)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '102354' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

27 (0.196)

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 = '102354' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

28 (0.152)

SELECT a.attribute_id, a.arata, 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 = '102354' AND a.attribute_group_id = '12' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

29 (0.075)

SELECT *
FROM oc_product_image
WHERE product_id = '102354'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

30 (0.601)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '108021' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

31 (0.197)

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 = '108021' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

32 (0.159)

SELECT a.attribute_id, a.arata, 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 = '108021' AND a.attribute_group_id = '7' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

33 (0.133)

SELECT *
FROM oc_product_image
WHERE product_id = '108021'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

34 (0.549)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '112023' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

35 (0.197)

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 = '112023' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

36 (0.135)

SELECT a.attribute_id, a.arata, 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 = '112023' AND a.attribute_group_id = '12' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

37 (0.066)

SELECT *
FROM oc_product_image
WHERE product_id = '112023'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

38 (0.552)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '104254' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

39 (0.190)

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 = '104254' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

40 (0.134)

SELECT a.attribute_id, a.arata, 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 = '104254' AND a.attribute_group_id = '37' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

41 (0.068)

SELECT *
FROM oc_product_image
WHERE product_id = '104254'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

42 (0.558)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '128766' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

43 (0.206)

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 = '128766' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

44 (0.164)

SELECT a.attribute_id, a.arata, 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 = '128766' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

45 (0.084)

SELECT *
FROM oc_product_image
WHERE product_id = '128766'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

46 (0.549)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '104253' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

47 (0.145)

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 = '104253' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

48 (0.132)

SELECT a.attribute_id, a.arata, 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 = '104253' AND a.attribute_group_id = '37' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

49 (0.065)

SELECT *
FROM oc_product_image
WHERE product_id = '104253'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

50 (0.545)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '106802' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

51 (0.151)

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 = '106802' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

52 (0.143)

SELECT a.attribute_id, a.arata, 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 = '106802' AND a.attribute_group_id = '13' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

53 (0.067)

SELECT *
FROM oc_product_image
WHERE product_id = '106802'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

54 (0.542)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '112270' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

55 (0.151)

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 = '112270' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

56 (0.144)

SELECT a.attribute_id, a.arata, 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 = '112270' AND a.attribute_group_id = '12' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

57 (0.066)

SELECT *
FROM oc_product_image
WHERE product_id = '112270'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

58 (0.538)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '104276' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

59 (0.152)

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 = '104276' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

60 (0.198)

SELECT a.attribute_id, a.arata, 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 = '104276' AND a.attribute_group_id = '12' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

61 (0.067)

SELECT *
FROM oc_product_image
WHERE product_id = '104276'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

62 (0.538)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '112135' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

63 (0.149)

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 = '112135' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

64 (0.141)

SELECT a.attribute_id, a.arata, 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 = '112135' AND a.attribute_group_id = '13' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

65 (0.067)

SELECT *
FROM oc_product_image
WHERE product_id = '112135'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

66 (0.541)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '120333' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

67 (0.160)

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 = '120333' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

68 (0.169)

SELECT a.attribute_id, a.arata, 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 = '120333' AND a.attribute_group_id = '8' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

69 (0.073)

SELECT *
FROM oc_product_image
WHERE product_id = '120333'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

70 (0.546)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '107079' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

71 (0.146)

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 = '107079' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

72 (0.132)

SELECT a.attribute_id, a.arata, 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 = '107079' AND a.attribute_group_id = '37' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

73 (0.066)

SELECT *
FROM oc_product_image
WHERE product_id = '107079'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

74 (0.587)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '112100' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

75 (0.148)

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 = '112100' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

76 (0.141)

SELECT a.attribute_id, a.arata, 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 = '112100' AND a.attribute_group_id = '13' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

77 (0.066)

SELECT *
FROM oc_product_image
WHERE product_id = '112100'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

78 (0.541)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '106572' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

79 (0.149)

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 = '106572' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

80 (0.138)

SELECT a.attribute_id, a.arata, 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 = '106572' AND a.attribute_group_id = '42' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

81 (0.066)

SELECT *
FROM oc_product_image
WHERE product_id = '106572'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

82 (0.538)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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 ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') AS weight_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(1) 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 (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '105293' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

83 (0.153)

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 = '105293' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1295

84 (0.147)

SELECT a.attribute_id, a.arata, 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 = '105293' AND a.attribute_group_id = '12' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1300

85 (0.065)

SELECT *
FROM oc_product_image
WHERE product_id = '105293'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1396

86 (0.075)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"GIVADI COM SRL"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

87 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=112083'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

88 (0.067)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"MIM TEAM S.R.L"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

89 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=112024'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

90 (0.120)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=107929'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

91 (0.118)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ARROW INTERNATIONAL"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

92 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=100346'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

93 (0.070)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"BEST FOR FISHING SRL"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

94 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=101139'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

95 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=102354'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

96 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=108021'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

97 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=112023'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

98 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=104254'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

99 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=128766'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

100 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=104253'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

101 (0.071)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"NASH NOU"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

102 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=106802'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

103 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=112270'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

104 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=104276'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

105 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=112135'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

106 (0.068)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PURE FISHING EUROPE SAS"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

107 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=120333'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

108 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=107079'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

109 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=112100'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

110 (0.067)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"WATSON AND CO S.R.L."%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

111 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=106572'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

112 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=105293'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

113 (0.083)

SELECT layout_id
FROM oc_layout_route
WHERE 'product/search' LIKE route AND store_id = '3'
ORDER BY route DESC LIMIT 1

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:8

114 (0.079)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'column_left'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

115 (0.054)

SELECT *
FROM oc_module
WHERE module_id = '1183'

/var/www/clients/client1/web1/web/catalog/model/extension/module.php:16

116 (6.492)

SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248

117 (0.108)

SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270

118 (1.605)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035

119 (89.214)

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949

120 (0.148)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'column_right'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

121 (0.129)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'content_top'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

122 (0.122)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'content_bottom'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

123 (0.835)

SELECT *
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 id.language_id = '2' AND i2s.store_id = '3' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:23

124 (0.544)

SELECT *
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.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

125 (0.490)

SELECT *
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.parent_id = '217' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

126 (0.326)

SELECT *
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.parent_id = '218' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

127 (0.294)

SELECT *
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.parent_id = '483' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

128 (0.332)

SELECT *
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.parent_id = '84' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

129 (0.271)

SELECT *
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.parent_id = '222' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

130 (0.268)

SELECT *
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.parent_id = '279' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

131 (0.289)

SELECT *
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.parent_id = '380' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

132 (0.322)

SELECT *
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.parent_id = '637' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

133 (0.411)

SELECT *
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.parent_id = '225' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

134 (0.383)

SELECT *
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.parent_id = '92' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

135 (0.330)

SELECT *
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.parent_id = '653' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

136 (0.286)

SELECT *
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.parent_id = '223' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

137 (0.412)

SELECT *
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.parent_id = '487' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

138 (0.342)

SELECT *
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.parent_id = '453' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

139 (0.355)

SELECT *
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.parent_id = '224' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

140 (0.383)

SELECT *
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.parent_id = '262' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

141 (0.403)

SELECT *
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.parent_id = '88' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

142 (0.439)

SELECT *
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.parent_id = '270' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

143 (0.275)

SELECT *
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.parent_id = '271' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

144 (0.268)

SELECT *
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.parent_id = '272' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

145 (0.264)

SELECT *
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.parent_id = '293' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

146 (0.275)

SELECT *
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.parent_id = '382' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

147 (0.276)

SELECT *
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.parent_id = '278' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

148 (0.352)

SELECT *
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.parent_id = '274' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

149 (0.279)

SELECT *
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.parent_id = '277' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

150 (0.276)

SELECT *
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.parent_id = '779' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

151 (0.314)

SELECT *
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.parent_id = '644' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

152 (0.281)

SELECT *
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.parent_id = '435' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

153 (0.328)

SELECT *
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.parent_id = '422' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

154 (0.318)

SELECT *
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.parent_id = '441' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

155 (0.362)

SELECT *
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.parent_id = '276' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

156 (0.273)

SELECT *
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.parent_id = '439' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

157 (0.351)

SELECT *
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.parent_id = '396' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

158 (0.458)

SELECT *
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.parent_id = '220' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

159 (0.275)

SELECT *
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.parent_id = '226' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

160 (0.273)

SELECT *
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.parent_id = '390' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

161 (0.265)

SELECT *
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.parent_id = '392' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

162 (0.274)

SELECT *
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.parent_id = '227' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

163 (0.267)

SELECT *
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.parent_id = '393' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

164 (0.265)

SELECT *
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.parent_id = '292' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

165 (0.265)

SELECT *
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.parent_id = '383' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

166 (0.362)

SELECT *
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.parent_id = '491' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

167 (0.336)

SELECT *
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.parent_id = '651' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

168 (0.276)

SELECT *
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.parent_id = '229' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

169 (0.268)

SELECT *
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.parent_id = '230' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

170 (0.333)

SELECT *
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.parent_id = '228' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

171 (0.269)

SELECT *
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.parent_id = '231' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

172 (0.279)

SELECT *
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.parent_id = '421' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

173 (0.266)

SELECT *
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.parent_id = '434' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

174 (0.592)

SELECT *
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.parent_id = '355' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

175 (0.328)

SELECT *
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.parent_id = '387' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

176 (0.296)

SELECT *
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.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

177 (0.272)

SELECT *
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.parent_id = '405' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

178 (0.419)

SELECT *
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.parent_id = '250' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

179 (0.271)

SELECT *
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.parent_id = '251' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

180 (0.269)

SELECT *
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.parent_id = '252' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

181 (0.266)

SELECT *
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.parent_id = '661' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

182 (0.266)

SELECT *
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.parent_id = '741' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

183 (0.263)

SELECT *
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.parent_id = '256' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

184 (0.273)

SELECT *
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.parent_id = '727' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

185 (0.270)

SELECT *
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.parent_id = '769' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

186 (0.320)

SELECT *
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.parent_id = '781' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

187 (0.274)

SELECT *
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.parent_id = '257' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

188 (0.272)

SELECT *
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.parent_id = '253' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

189 (0.272)

SELECT *
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.parent_id = '255' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

190 (0.263)

SELECT *
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.parent_id = '632' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

191 (0.262)

SELECT *
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.parent_id = '263' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

192 (0.263)

SELECT *
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.parent_id = '636' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

193 (0.472)

SELECT *
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.parent_id = '221' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

194 (0.361)

SELECT *
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.parent_id = '258' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

195 (0.268)

SELECT *
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.parent_id = '269' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

196 (0.267)

SELECT *
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.parent_id = '370' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

197 (0.364)

SELECT *
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.parent_id = '261' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

198 (0.270)

SELECT *
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.parent_id = '259' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

199 (0.273)

SELECT *
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.parent_id = '268' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

200 (0.273)

SELECT *
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.parent_id = '384' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

201 (0.311)

SELECT *
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.parent_id = '266' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

202 (0.329)

SELECT *
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.parent_id = '789' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

203 (0.326)

SELECT *
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.parent_id = '719' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

204 (0.268)

SELECT *
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.parent_id = '264' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

205 (0.266)

SELECT *
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.parent_id = '777' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

206 (0.312)

SELECT *
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.parent_id = '643' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

207 (0.270)

SELECT *
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.parent_id = '436' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

208 (0.268)

SELECT *
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.parent_id = '137' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

209 (0.318)

SELECT *
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.parent_id = '693' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

210 (0.320)

SELECT *
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.parent_id = '677' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

211 (0.270)

SELECT *
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.parent_id = '119' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

212 (0.270)

SELECT *
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.parent_id = '180' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

213 (0.266)

SELECT *
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.parent_id = '440' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

214 (0.263)

SELECT *
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.parent_id = '543' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

215 (0.375)

SELECT *
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.parent_id = '282' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

216 (0.287)

SELECT *
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.parent_id = '285' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

217 (0.269)

SELECT *
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.parent_id = '286' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

218 (0.271)

SELECT *
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.parent_id = '290' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

219 (0.260)

SELECT *
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.parent_id = '287' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

220 (0.306)

SELECT *
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.parent_id = '650' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

221 (0.267)

SELECT *
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.parent_id = '381' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

222 (0.324)

SELECT *
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.parent_id = '284' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

223 (0.298)

SELECT *
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.parent_id = '288' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

224 (0.359)

SELECT *
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.parent_id = '306' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

225 (0.283)

SELECT *
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.parent_id = '178' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

226 (0.266)

SELECT *
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.parent_id = '172' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

227 (0.265)

SELECT *
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.parent_id = '419' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

228 (0.264)

SELECT *
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.parent_id = '325' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

229 (0.262)

SELECT *
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.parent_id = '75' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

230 (0.270)

SELECT *
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.parent_id = '198' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

231 (0.264)

SELECT *
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.parent_id = '787' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

232 (0.435)

SELECT *
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.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

233 (0.276)

SELECT *
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.parent_id = '204' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

234 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

235 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=204'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

236 (0.350)

SELECT *
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.parent_id = '96' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

237 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

238 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=96'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

239 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=326'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

240 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

241 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=96'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

242 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=327'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

243 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

244 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=96'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

245 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=239'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

246 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

247 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=96'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

248 (0.281)

SELECT *
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.parent_id = '94' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

249 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

250 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=94'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

251 (0.274)

SELECT *
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.parent_id = '579' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

252 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

253 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=579'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

254 (0.268)

SELECT *
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.parent_id = '202' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

255 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

256 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=202'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

257 (0.270)

SELECT *
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.parent_id = '97' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

258 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

259 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=97'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

260 (0.418)

SELECT *
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.parent_id = '93' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

261 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

262 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

263 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=473'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

264 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

265 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

266 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=336'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

267 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

268 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

269 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=337'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

270 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

271 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

272 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=352'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

273 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

274 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

275 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=341'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

276 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

277 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

278 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=338'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

279 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

280 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

281 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=335'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

282 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

283 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

284 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=333'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

285 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

286 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

287 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=332'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

288 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

289 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

290 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=334'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

291 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

292 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

293 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=339'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

294 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

295 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

296 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=340'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

297 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

298 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

299 (0.281)

SELECT *
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.parent_id = '254' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

300 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

301 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=254'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

302 (0.278)

SELECT *
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.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

303 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

304 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

305 (0.269)

SELECT *
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.parent_id = '141' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

306 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

307 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=141'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

308 (0.265)

SELECT *
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.parent_id = '575' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

309 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

310 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=575'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

311 (0.269)

SELECT *
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.parent_id = '471' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

312 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

313 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=471'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

314 (0.278)

SELECT *
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.parent_id = '577' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

315 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

316 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=577'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

317 (0.278)

SELECT *
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.parent_id = '417' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

318 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

319 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=417'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

320 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

321 (0.390)

SELECT *
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.parent_id = '106' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

322 (0.279)

SELECT *
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.parent_id = '591' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

323 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

324 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=591'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

325 (0.277)

SELECT *
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.parent_id = '109' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

326 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

327 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=109'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

328 (0.269)

SELECT *
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.parent_id = '108' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

329 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

330 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=108'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

331 (0.443)

SELECT *
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.parent_id = '673' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

332 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

333 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

334 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=114'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

335 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

336 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

337 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=674'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

338 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

339 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

340 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=585'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

341 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

342 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

343 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=581'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

344 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

345 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

346 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=583'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

347 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

348 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

349 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=245'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

350 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

351 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

352 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=675'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

353 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

354 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

355 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=107'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

356 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

357 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

358 (0.468)

SELECT *
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.parent_id = '111' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

359 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

360 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

361 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=601'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

362 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

363 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

364 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=481'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

365 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

366 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

367 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=587'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

368 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

369 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

370 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=348'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

371 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

372 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

373 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=589'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

374 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

375 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

376 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=349'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

377 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

378 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

379 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=595'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

380 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

381 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

382 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=404'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

383 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

384 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

385 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=397'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

386 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

387 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

388 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=599'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

389 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

390 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

391 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=603'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

392 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

393 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

394 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=597'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

395 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

396 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

397 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=351'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

398 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

399 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

400 (0.285)

SELECT *
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.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

401 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

402 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=113'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

403 (0.273)

SELECT *
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.parent_id = '438' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

404 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

405 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=438'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

406 (0.268)

SELECT *
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.parent_id = '112' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

407 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

408 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=112'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

409 (0.270)

SELECT *
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.parent_id = '110' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

410 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

411 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=110'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

412 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

413 (0.462)

SELECT *
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.parent_id = '151' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

414 (0.277)

SELECT *
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.parent_id = '743' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

415 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

416 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=743'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

417 (0.288)

SELECT *
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.parent_id = '158' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

418 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

419 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=158'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

420 (0.268)

SELECT *
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.parent_id = '215' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

421 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

422 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=215'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

423 (0.275)

SELECT *
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.parent_id = '682' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

424 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

425 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=682'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

426 (0.329)

SELECT *
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.parent_id = '679' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

427 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

428 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

429 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=152'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

430 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

431 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

432 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=680'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

433 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

434 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

435 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=690'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

436 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

437 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

438 (0.278)

SELECT *
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.parent_id = '541' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

439 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

440 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=541'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

441 (0.274)

SELECT *
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.parent_id = '681' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

442 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

443 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

444 (0.355)

SELECT *
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.parent_id = '208' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

445 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

446 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

447 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=802'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

448 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

449 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

450 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=803'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

451 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

452 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

453 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=804'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

454 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

455 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

456 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=801'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

457 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

458 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

459 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=805'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

460 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

461 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

462 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=806'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

463 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

464 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

465 (0.362)

SELECT *
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.parent_id = '609' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

466 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

467 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

468 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=688'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

469 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

470 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

471 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=607'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

472 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

473 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

474 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=605'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

475 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

476 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

477 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=156'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

478 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

479 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

480 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=611'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

481 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

482 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

483 (0.270)

SELECT *
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.parent_id = '391' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

484 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

485 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=391'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

486 (0.263)

SELECT *
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.parent_id = '153' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

487 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

488 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=153'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

489 (0.271)

SELECT *
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.parent_id = '160' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

490 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

491 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=160'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

492 (0.280)

SELECT *
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.parent_id = '535' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

493 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

494 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=535'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

495 (0.347)

SELECT *
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.parent_id = '663' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

496 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

497 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

498 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=437'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

499 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

500 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

501 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=159'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

502 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

503 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

504 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=664'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

505 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

506 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

507 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=665'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

508 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

509 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

510 (0.270)

SELECT *
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.parent_id = '155' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

511 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

512 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=155'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

513 (0.269)

SELECT *
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.parent_id = '154' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

514 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

515 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=154'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

516 (0.278)

SELECT *
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.parent_id = '539' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

517 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

518 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=539'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

519 (0.276)

SELECT *
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.parent_id = '537' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

520 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

521 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=537'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

522 (0.383)

SELECT *
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.parent_id = '666' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

523 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

524 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

525 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=686'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

526 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

527 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

528 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=697'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

529 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

530 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

531 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=669'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

532 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

533 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

534 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=672'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

535 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

536 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

537 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

538 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

539 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

540 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=667'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

541 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

542 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

543 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=157'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

544 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

545 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

546 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=671'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

547 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

548 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

549 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=668'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

550 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

551 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

552 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

553 (0.404)

SELECT *
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.parent_id = '98' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

554 (0.491)

SELECT *
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.parent_id = '647' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

555 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

556 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

557 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=105'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

558 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

559 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

560 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=709'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

561 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

562 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

563 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=757'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

564 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

565 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

566 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=101'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

567 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

568 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

569 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=102'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

570 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

571 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

572 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=401'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

573 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

574 (0.216)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

575 (0.166)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=749'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

576 (0.177)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

577 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

578 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=715'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

579 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

580 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

581 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=400'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

582 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

583 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

584 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=403'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

585 (0.354)

SELECT *
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.parent_id = '648' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

586 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

587 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

588 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=399'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

589 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

590 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

591 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=398'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

592 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

593 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

594 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

595 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

596 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

597 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=717'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

598 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

599 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

600 (0.419)

SELECT *
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.parent_id = '649' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

601 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

602 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

603 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=763'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

604 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

605 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

606 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=503'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

607 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

608 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

609 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=753'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

610 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

611 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

612 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=99'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

613 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

614 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

615 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=388'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

616 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

617 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

618 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=713'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

619 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

620 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

621 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=297'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

622 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

623 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

624 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=711'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

625 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

626 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

627 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=104'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

628 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

629 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

630 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=646'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

631 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

632 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

633 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=755'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

634 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

635 (0.059)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

636 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=751'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

637 (0.175)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

638 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

639 (0.354)

SELECT *
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.parent_id = '684' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

640 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

641 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=684'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

642 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=735'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

643 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

644 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=684'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

645 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=737'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

646 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

647 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=684'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

648 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=739'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

649 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

650 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=684'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

651 (0.283)

SELECT *
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.parent_id = '418' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

652 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

653 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=418'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

654 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

655 (0.374)

SELECT *
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.parent_id = '120' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

656 (0.397)

SELECT *
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.parent_id = '655' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

657 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

658 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

659 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=557'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

660 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

661 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

662 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=561'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

663 (0.062)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

664 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

665 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=289'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

666 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

667 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

668 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=275'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

669 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

670 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

671 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=555'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

672 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

673 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

674 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=545'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

675 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

676 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

677 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=559'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

678 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

679 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

680 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=549'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

681 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

682 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

683 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=747'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

684 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

685 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

686 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=571'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

687 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

688 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

689 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=547'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

690 (0.328)

SELECT *
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.parent_id = '121' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

691 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

692 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=121'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

693 (0.389)

SELECT *
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.parent_id = '123' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

694 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

695 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

696 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=689'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

697 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

698 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

699 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=553'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

700 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

701 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

702 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=773'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

703 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

704 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

705 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=551'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

706 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

707 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

708 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=567'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

709 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

710 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

711 (0.300)

SELECT *
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.parent_id = '565' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

712 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

713 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=565'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

714 (0.290)

SELECT *
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.parent_id = '395' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

715 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

716 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=395'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

717 (0.291)

SELECT *
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.parent_id = '122' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

718 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

719 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=122'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

720 (0.291)

SELECT *
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.parent_id = '563' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

721 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

722 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=563'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

723 (0.415)

SELECT *
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.parent_id = '189' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

724 (0.300)

SELECT *
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.parent_id = '195' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

725 (0.298)

SELECT *
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.parent_id = '192' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

726 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

727 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=192'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

728 (0.288)

SELECT *
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.parent_id = '191' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

729 (0.290)

SELECT *
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.parent_id = '194' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

730 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

731 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=194'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

732 (0.287)

SELECT *
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.parent_id = '211' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

733 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

734 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=211'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

735 (0.282)

SELECT *
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.parent_id = '190' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

736 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

737 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=190'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

738 (0.292)

SELECT *
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.parent_id = '725' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

739 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

740 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=725'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

741 (0.390)

SELECT *
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.parent_id = '654' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

742 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

743 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=654'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

744 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=193'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

745 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

746 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=654'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

747 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=389'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

748 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

749 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=654'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

750 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=373'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

751 (0.294)

SELECT *
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.parent_id = '377' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

752 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

753 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=377'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

754 (0.297)

SELECT *
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.parent_id = '729' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

755 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

756 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=729'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

757 (0.390)

SELECT *
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.parent_id = '128' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

758 (0.278)

SELECT *
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.parent_id = '745' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

759 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

760 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=745'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

761 (0.287)

SELECT *
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.parent_id = '129' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

762 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

763 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=129'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

764 (0.290)

SELECT *
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.parent_id = '394' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

765 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

766 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=394'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

767 (0.296)

SELECT *
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.parent_id = '132' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

768 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

769 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=132'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

770 (0.288)

SELECT *
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.parent_id = '130' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

771 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

772 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=130'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

773 (0.361)

SELECT *
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.parent_id = '635' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

774 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

775 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

776 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=657'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

777 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

778 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

779 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=658'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

780 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

781 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

782 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=659'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

783 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

784 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

785 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=660'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

786 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

787 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

788 (0.313)

SELECT *
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.parent_id = '131' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

789 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

790 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=131'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

791 (0.299)

SELECT *
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.parent_id = '447' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

792 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

793 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=447'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

794 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

795 (0.330)

SELECT *
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.parent_id = '133' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

796 (0.309)

SELECT *
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.parent_id = '629' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

797 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

798 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=629'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

799 (0.300)

SELECT *
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.parent_id = '631' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

800 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

801 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=631'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

802 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

803 (0.394)

SELECT *
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.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

804 (0.276)

SELECT *
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.parent_id = '415' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

805 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

806 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=415'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

807 (0.279)

SELECT *
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.parent_id = '301' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

808 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

809 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=301'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

810 (0.272)

SELECT *
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.parent_id = '304' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

811 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

812 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=304'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

813 (0.278)

SELECT *
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.parent_id = '300' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

814 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

815 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=300'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

816 (0.290)

SELECT *
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.parent_id = '303' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

817 (0.276)

SELECT *
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.parent_id = '302' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

818 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

819 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=302'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

820 (0.291)

SELECT *
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.parent_id = '299' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

821 (0.282)

SELECT *
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.parent_id = '371' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

822 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

823 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=371'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

824 (0.290)

SELECT *
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.parent_id = '196' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

825 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

826 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=196'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

827 (0.072)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produse ce potrivesc criteriilor de căutare

Carlige BKK ISEAMA Diamond Black Nickel Nr.12 12buc/plic

Fir Asso Mainline Master Green 0.40mm 1000m

STOPER TRABUCCO SMALL BLACK MARIME S 15BUC/PLIC

CHOD BUFFER PROLOGIC 15BUC/PL

PLUMB JAXON CRAP RAPID MAROU 100GR

Fir Owner Lead Core Technora Line 1.00mm 5m

LANSETA K-KARP FUSION SPOD 3.60 4LBS 2 SEG

Fir Asso Mainline Master Green 0.35mm 1000m

INELE K-KARP ATR ROUND RING 3.7 20BUC/PLIC

MULINETA PROLOGIC ELEMENT XD 7000 BF 6 plus 1BB

INELE K-KARP ATR ROUND RING 3.0 20BUC/PLIC

Carlige Nash Twister Size 2 Micro Barbed

Fir monofilament Fox Exocet Fluoro Orange Mono 0.28mm/5.50kg/1000

Fir Textil K-Karp Dyna Tex Elusive 20m Camo Green 35lbs

Carlige BKK Chinu Shark Nr.10 12buc/plic

Mulineta Penn Rival Longcast Gold 6000

KWIK FOX CHANGE POP-UP WEIGHTS ADDITIONS nr 1

Carlige BKK Chinu Diamond Black Nickel Nr.8 12buc/plic

Kryston MONTURA KRYSTON D-STIFF RIG INCOGNITO 15lb 2

FIR TRABUCCO T FORCE TOUR. S/HARD 300M 0.350MM 15.95 Kg

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare