Palms

Sortare după:

Vobler Palms S-Crawl 65mm, 5.1g, SL155

sc-65s/sl155

Livrare 48-72ore

72,00Lei

Vobler PALMS Subream Mebaru Tune 40F, T181, 4cm, 2.5g

sum-40f/t-181

Livrare 48-72ore

49,00Lei

Vobler Palms Alexandra Shade 4.3cm 5.3g ST95-5

axs-43s /st95 #5

Livrare 48-72ore

75,01Lei

VOBLER PALMS BEATRICE AL519 SINKING 8CM 18G

bt-80s/al-519

Livrare 48-72ore

75,01Lei

Vobler Palms C-Crawl 45mm, 7g, SL155

cc-45s/sl155

Livrare 48-72ore

65,00Lei

Vobler PALMS Curref Joited, T328, 7cm, 8.3g

cf-70js/t-328

Livrare 48-72ore

63,00Lei

Vobler Palms Beatrice 4.5cm 2.9g Sinking A105

bt-45s/a105

Livrare 48-72ore

60,00Lei

Vobler Palms Alexandra Flutter MG328 5cm 3.2g 1buc/plic

ax-50fs/mg328

Livrare 48-72ore

70,00Lei

Vobler PALMS C-Crawl, MAL51, 3.5cm, 4g

cc-35s/mal-51

Livrare 48-72ore

63,00Lei

Lingura rotativa Palms Spin Walk Clevis 3g SGR

spw-cv-3/sgr

Livrare 48-72ore

35,00Lei

Vobler PALMS Alexandra AX-60XHW, MG441, 6cm, 8.3g

ax-60xhw/mg441

Livrare 48-72ore

80,00Lei

Vobler PALMS Javami Lipless 135F, P23, 13.5cm, 26g

jml-135f/p23

Livrare 48-72ore

75,01Lei

Vobler Palms Stroud 55F Smelt 5.5cm 3.3g AL-51

sr-55f/al-51

Livrare 48-72ore

63,00Lei

Vobler Palms S-Crawl 65mm, 5.1g, KI464

sc-65s/ki464

Livrare 48-72ore

72,00Lei

Lanseta PALMS Egeria Area UL, 1.8m, 1-4g, 2seg

etgs-60ul

Livrare 48-72ore

690,00Lei

Vobler Palms Alexandra Shade 4.3cm 5.3g AL34-1

axs-43s /al34 #1

Livrare 48-72ore

75,01Lei

VOBLER PALMS BEATRICE A94 SINKING 6.5CM 10G

bt-65s/a-94

Livrare 48-72ore

70,00Lei

Vobler PALMS Curref Joited, H98, 7cm, 8.3g

cf-70js/h-98

Livrare 48-72ore

63,00Lei

Vobler Palms Alexandra Flutter ABS 5cm 3.2g 1buc/plic

ax-50fs/abs

Livrare 48-72ore

70,00Lei

Vobler Palms Rattlin Vibe VIBROSSI 50mm 6.5g VR-50 IT

vr-50/it

Livrare 48-72ore

53,00Lei

Afişare 101 - 120 din 159 (8 pagini)

Queries: 37, Total time: 109.542 ms [By time] [By id] [By file]

1 (0.087)

SELECT data
FROM `oc_session`
WHERE session_id = '46dc82047765ee9b3c9cfafd5d'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.097)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.119)

SELECT *
FROM oc_url_alias
WHERE keyword = 'palms.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.105)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '583' AND m2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (51.130)

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 = '583'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (52.935)

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 = '583' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.924)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '160585' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

8 (0.293)

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '160585' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297

9 (0.250)

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '160585' AND a.attribute_group_id = '23' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302

10 (0.097)

SELECT *
FROM oc_product_image
WHERE product_id = '160585'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398

11 (0.848)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '160675' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

12 (0.234)

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '160675' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297

13 (0.229)

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '160675' AND a.attribute_group_id = '23' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302

14 (0.101)

SELECT *
FROM oc_product_image
WHERE product_id = '160675'
ORDER BY sort_order ASC

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398

15 (0.104)