RAID


Vobler RAID JAPAN Level VIB, 010 Chi Gill, 5.4cm, 10.6g

Vobler RAID JAPAN Level VIB, 010 Chi Gill, 5.4cm, 10.6g

raid30185
Livrare imediată!

97,60Lei

Vobler Raid Level Minnow Floating, 005 Gross Wakasagi, 14g, 12.5cm, 1buc/pac

Vobler Raid Level Minnow Floating, 005 Gross Wakasagi, 14g, 12.5cm, 1buc/pac

raid34466
Livrare 48-72 ore

114,88Lei

Cicada Raid Japan Level VIB Boost, 026 Real Kinkuro, 3.8cm, 7g

Cicada Raid Japan Level VIB Boost, 026 Real Kinkuro, 3.8cm, 7g

raid20404
Livrare imediată!

80,31Lei

Swimbait RAID Head Swimmer Libero, 009 White Chartreuse, 10g, 2buc/pac

Swimbait RAID Head Swimmer Libero, 009 White Chartreuse, 10g, 2buc/pac

raid16216
Livrare imediată!

71,16Lei

Vobler RAID JAPAN Level Crank, 004 Pearl Shad, 5.1cm, 10.5g

Vobler RAID JAPAN Level Crank, 004 Pearl Shad, 5.1cm, 10.5g

raid31533
Livrare imediată!

97,60Lei

Vobler RAID JAPAN Level Crank Mid, 008 Pearl Shad, 5.9cm, 10.5g

Vobler RAID JAPAN Level Crank Mid, 008 Pearl Shad, 5.9cm, 10.5g

raid33308
Livrare imediată!

97,60Lei

Vobler RAID JAPAN Level Minnow Quick72, 014 Uroko, 7.2cm, 5.2g

Vobler RAID JAPAN Level Minnow Quick72, 014 Uroko, 7.2cm, 5.2g

raid22156
Livrare imediată!

97,60Lei

Cicada RAID JAPAN Level VIB Boost, 004 Kinkuro, 3.8cm, 7.0g

Cicada RAID JAPAN Level VIB Boost, 004 Kinkuro, 3.8cm, 7.0g

raid32080
Livrare imediată!

80,31Lei

Vobler RAID JAPAN Level VIB B.I.G., 006 Chi Gill, 6.3cm, 17.0g

Vobler RAID JAPAN Level VIB B.I.G., 006 Chi Gill, 6.3cm, 17.0g

raid34367
Livrare imediată!

104,71Lei

Vobler Raid Level Minnow Floating, 019 Clear Squash, 14g, 12.5cm, 1buc/pac

Vobler Raid Level Minnow Floating, 019 Clear Squash, 14g, 12.5cm, 1buc/pac

raid49491
Livrare 48-72 ore

114,88Lei

Creatura Raid Egu Chunk, Junebug, 8.9cm, 6buc/pac

Creatura Raid Egu Chunk, Junebug, 8.9cm, 6buc/pac

raid13666
Livrare 48-72 ore

50,82Lei

Cicada Raid Japan Level VIB Boost, 001 Shimanashi Tiger, 3.8cm, 5g

Cicada Raid Japan Level VIB Boost, 001 Shimanashi Tiger, 3.8cm, 5g

raid31977
Livrare imediată!

80,31Lei

Vobler RAID GI, 007 Chi Gill, 9.4cm, 35.0g

Vobler RAID GI, 007 Chi Gill, 9.4cm, 35.0g

raid11433
Livrare imediată!

212,50Lei

Swimbait RAID Head Swimmer Libero, 003 Ice Black, 7g, 2buc/pac

Swimbait RAID Head Swimmer Libero, 003 Ice Black, 7g, 2buc/pac

raid49828
Livrare imediată!

71,16Lei

Vobler RAID JAPAN Level Minnow Quick72, 002 Lemon Power, 7.2cm, 5.2g

Vobler RAID JAPAN Level Minnow Quick72, 002 Lemon Power, 7.2cm, 5.2g

raid14670
Livrare imediată!

97,60Lei

Shad RAID Level Sprinter 68MR, 011 Grape Bijin, 6.8cm, 5.9g

Shad RAID Level Sprinter 68MR, 011 Grape Bijin, 6.8cm, 5.9g

raid43215
Livrare imediată!

97,60Lei

Cicada RAID JAPAN Level VIB Boost, 021 Smoke Gill, 4.6cm, 11.0g

Cicada RAID JAPAN Level VIB Boost, 021 Smoke Gill, 4.6cm, 11.0g

raid44137
Livrare imediată!

86,41Lei

Creatura Raid Oka Ebi, Dark Cinnamon Blu FLK 020, 6.3cm, 6buc/pac

Creatura Raid Oka Ebi, Dark Cinnamon Blu FLK 020, 6.3cm, 6buc/pac

raid45264
Livrare 48-72 ore

50,82Lei

Vobler Raid Level Minnow Plus Floating, 005 Clown, 14g, 12.5cm, 1buc/pac

Vobler Raid Level Minnow Plus Floating, 005 Clown, 14g, 12.5cm, 1buc/pac

raid46124
Livrare 48-72 ore

114,88Lei

Creatura Raid Egu Bug, Natural Weapon, 6.3cm, 8buc/pac

Creatura Raid Egu Bug, Natural Weapon, 6.3cm, 8buc/pac

raid13352
Livrare 48-72 ore

48,79Lei

Afişare 81 - 100 din 394 (20 pagini)
Queries: 7, Total time: 63.861 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = 'e12320cdceedda56f1fa342f2a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.177)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.163)
SELECT *
FROM oc_url_alias
WHERE keyword = 'raid.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.152)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '729' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (27.571)
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 = '729'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (35.525)
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 = '729' 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.164)
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