Bass Assassin


BASS ASSASSIN ELITE SHINER 10CM MAMA S 8buc/plic

bsawes50312
Livrare imediată!

23,22Lei

SHAD BASS ASSASSIN DIE DAPPER 8.9CM

bsadda78331
Livrare imediată!

31,91Lei

27,44Lei

BASS ASSASSIN ELITE SHINER 10CM MEAT HOOK

bsawes50338
Livrare imediată!

27,44Lei

41,58Lei

32,42Lei

21,34Lei

34,45Lei

34,45Lei

35,47Lei

35,47Lei

36,38Lei

SHAD BASS ASSASIN TURBO 10CM SMOKE WAGON

wa32339
Livrare imediată!

34,45Lei

30,00Lei(-33%) 20,24Lei

22,25Lei

30,00Lei(-33%) 20,24Lei

Shad Bass Assassin Elite Shiner Wakasagi 10cm

bsaes95311
Livrare imediată!

27,00Lei(-15%) 22,97Lei

34,45Lei

35,47Lei

35,47Lei

Afişare 21 - 40 din 102 (6 pagini)
Queries: 7, Total time: 62.433 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = 'd45a0e312180dbe66067b38591'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.156)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.146)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Bass-Assassin'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.143)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '309' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (26.789)
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 = '309'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (34.955)
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 = '309' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 20,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