Kamasaki


LANSETA KAMASAKI SUPER MATCH 3.90M

14041390
Livrare 24-48 ore

183,92Lei

CARLIGE LEGATE KAMASAKI K890BR NR 08

45403008
Livrare 24-48 ore

10,06Lei

203,24Lei

Vobler Kamasaki Bug COL:99 2.5cm 1.5g

87225299
Livrare imediată!

10,06Lei

10,06Lei

23,27Lei

10,06Lei

11,07Lei

10,66Lei

Cutie Kamasaki Superbox M0309 15x8x3cm

75010309
Livrare imediată!

9,34Lei

SUPORT KAMASAKI PAHAR DELUXE 22 cm

77041265
Livrare imediată!

43,71Lei

JIG KAMASAKI PRESSION JIG HEAD 3.5g 5buc/plic

59047003
Livrare imediată!

7,01Lei

23,39Lei

11,07Lei

ADAPTOR RAPID KAMASAKI ALBASTRU

77041232
Livrare imediată!

14,63Lei

Coada Minciog KAMASAKI Super, 3.00m

71080300
Livrare imediată!

74,11Lei

Coada Minciog Kamasaki Slim Feeder 3.00M

71081300
Livrare 24-48 ore

64,96Lei

AGRAFA KAMASAKI CU VARTEJ SAFETY NR.12

82254012
Livrare 24-48 ore

7,01Lei

Saltea Primire Crap 100X60cm Kamasaki

73756200
Livrare imediată!

47,77Lei

Varga KAMASAKI Power Pole, 4m, 5-35g, 4seg

11058400
Livrare 24-48 ore

99,53Lei

Afişare 81 - 100 din 238 (12 pagini)
Queries: 7, Total time: 81.733 ms [By time] [By id] [By file]
1 (0.125)
SELECT data
FROM `oc_session`
WHERE session_id = '1b5e1b999e0cd73684cd7915b0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.186)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.161)
SELECT *
FROM oc_url_alias
WHERE keyword = 'kamasaki.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.114)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '188' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (31.819)
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 = '188'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (49.206)
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 = '188' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.121)
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