Gamo


CUTIE METAL GAMO PRO MATCH 5,5MM 250BUC

g.6321825
Livrare 24-48 ore

29,86Lei

CAPSULE GAMO CO2 12 GRAME

g.6212470
Livrare 24-48 ore

6,64Lei

18,50Lei

CUTIE METAL GAMO MAGNUM 4,5MM 250BUC

g.6320224
Livrare 24-48 ore

16,59Lei

PACHET GAMO CU 100 TINTE HARTIE

g.6212106
Livrare imediată!

34,84Lei

CUTIE PLASTIC GAMO ROCKET 5,5MM 100BUC

g.6321285
Livrare imediată!

39,94Lei

PANTALONI SUREST HUNTING GREEN GAMO MAR. 58

g.453000035.54
Livrare imediată!

98,57Lei

STAND GAMO PENTRU REGLARE LUNETA

g.6212505
Livrare 24-48 ore

590,89Lei

CUTIE METAL GAMO PRO.MATCH 4,5MM 500BUC

g.6321834
Livrare imediată!

33,05Lei

CUTIE METAL GAMO MAGNUM 5,5MM 250BUC

g.6320225
Livrare 24-48 ore

30,62Lei

PRINDERE LUNETA GAMO FARA VIZARE-MEDIE

g.6213182
Livrare 24-48 ore

84,60Lei

CUTIE METAL GAMO TS-10 4,5MM 250BUC

g.6321748
Livrare imediată!

17,86Lei

PRINDERE LUNETA GAMO CU VIZARE-INALTA

g.6213183
Livrare 24-48 ore

94,41Lei

CUTIE METAL GAMO HUNTER 5,5MM 250BUC

g.6320825
Livrare 24-48 ore

29,86Lei

CUTIE METAL GAMO ALICE 4,5MM 500BUC

g.6320334
Livrare 24-48 ore

29,35Lei

PRINDERE LUNETA GAMO COMPACTA-MEDIE

g.6213184
Livrare 24-48 ore

130,66Lei

CUTIE METAL GAMO EXPANDER 5,5MM 250BUC

g.6322525
Livrare 24-48 ore

28,71Lei

HUSA GAMO ARMA+LUNETA L=125CM HARD

g.6212359
Livrare 24-48 ore

334,31Lei

CUTIE METAL GAMO HUNTER 4,5MM 500BUC

g.6320834
Livrare 24-48 ore

29,86Lei

CUTIE METAL GAMO HUNTER 6,35MM 200BUC

g.6320566
Livrare imediată!

33,69Lei

Afişare 1 - 20 din 24 (2 pagini)
Queries: 7, Total time: 39.556 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '82ef48be5b8994abafbb13b90e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.085)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Gamo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.087)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '82' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (19.934)
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 = '82'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (19.170)
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 = '82' 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.108)
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