Nash


59,95Lei

49,94Lei

59,95Lei

599,99Lei

1.199,98Lei

97,95Lei

689,99Lei

Carlige Nash Twister Size 8 Micro Barbed

t6113
Livrare imediată!

28,99Lei

Bluza Nash Half Zip Jumper Marime XL

c5683
Livrare imediată!

209,99Lei(-31%) 144,51Lei

Montura Nash Fluoro D Rig nr.8

t6372
Livrare imediată!

14,79Lei

29,99Lei

Cort Nash Titan T1 Camo Pro

t4234
Livrare imediată!

4.399,99Lei

127,35Lei

339,99Lei

105,01Lei

339,99Lei

115,00Lei

Pantaloni Nash Tackle Joggers Green XXXL

c1152
Livrare imediată!

175,99Lei(-26%) 130,90Lei

Montura Nash Ronnie Claw nr.4

t6352
Livrare imediată!

14,79Lei

474,95Lei

Afişare 1 - 20 din 656 (33 pagini)
Queries: 7, Total time: 94.623 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = '6a4e0b84a1aa2a3d1757f47a42'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.108)
SELECT *
FROM oc_url_alias
WHERE keyword = 'nash.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.125)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '59' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (39.090)
SELECT COUNT(1) AS total
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '59'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (55.029)
SELECT p.product_id, (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 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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '59' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37