Zheng Fishing


285,71Lei

387,39Lei

39,64Lei

Varga Zheng Fishing Big Game, 6.30m, 6seg

4307246747727
Livrare imediată!

509,40Lei

661,92Lei

Pluta Zheng Fishing, N004, 35cm, 4.2g, 1buc/pac

8307245690235
Livrare imediată!

26,41Lei

Varga Zheng Fishing Mixt Game, 8.10m, 8seg

6198256627226
Livrare imediată!

479,99Lei

356,88Lei

Varga Zheng Fishing Mixt Game, 7.20m, 7seg

5307243350073
Livrare imediată!

438,23Lei

285,71Lei

356,88Lei

39,64Lei

Varga Zheng Fishing Big Game, 5.40m, 5seg

1307240222001
Livrare 48-72 ore

478,91Lei

560,24Lei

Pluta Zheng Fishing, N005, 42cm, 3.5g, 1buc/pac

2307244907958
Livrare imediată!

26,41Lei

Varga Zheng Fishing Big Game, 9.00m, 9seg

5307247435523
Livrare imediată!

661,92Lei

590,75Lei

Varga Zheng Fishing Mixt Game, 6.30m, 6seg

8307242213703
Livrare imediată!

387,39Lei

Pluta Zheng Fishing, N003, 32.5cm, 3g, 1buc/pac

7307243614159
Livrare imediată!

26,41Lei

Umbrela Zheng Fishing Reglabila, 2.20m

8307242488156
Livrare imediată!

224,70Lei

Afişare 1 - 20 din 212 (11 pagini)
Queries: 7, Total time: 63.845 ms [By time] [By id] [By file]
1 (0.199)
SELECT data
FROM `oc_session`
WHERE session_id = 'c58d1854821f4fb36f08e4ddd2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.162)
SELECT *
FROM oc_url_alias
WHERE keyword = 'zheng-fishing.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.129)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '776' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.583)
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 = '0' AND p.manufacturer_id = '776'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (32.514)
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 = '0' AND p.manufacturer_id = '776' 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.147)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37