CPK


BLUZA CPK CU PROTECTIE UV Camo Marime L

1000651
Livrare imediată!

150,90Lei

24,00Lei

31,55Lei

33,90Lei

30,90Lei

Carlige CPK Force Mugga Nr.6

1000099
Livrare imediată!

12,18Lei

28,50Lei

Atractant CPK Liquid Krill, 250ml

1000752
Livrare imediată!

40,90Lei

35,90Lei

Tricou CPK Military Bagman, Marime XXL

1000980
Livrare imediată!

69,90Lei

30,90Lei

11,89Lei

Croseta CPK Splicing Needle

1000719
Livrare imediată!

19,90Lei

31,55Lei

Tricou CPK Military Pop Up, Marime S

1000971
Livrare imediată!

69,90Lei

Wafter CPK STINKY FISH 10/14 mm

999831
Livrare imediată!

33,90Lei

Wafters CPK Bicolor Squid Capsuna 8mm

1000630
Livrare imediată!

26,90Lei

BLUZA CPK CU PROTECTIE UV Marime M

1000171
Livrare imediată!

150,90Lei

Aditiv Cpk Baza Groundbait, Usturoi, 250ml

1000810
Livrare imediată!

12,90Lei

30,90Lei

Afişare 121 - 140 din 524 (27 pagini)
Queries: 7, Total time: 72.614 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '9b3f9dc222ae5b44d84df4c20e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.117)
SELECT *
FROM oc_url_alias
WHERE keyword = 'CPK'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.113)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '100' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.921)
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 = '100'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (36.130)
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 = '100' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,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