Căutare

Queries: 10, Total time: 1,081.737 ms [By time] [By id] [By file]

1 (0.106)

SELECT data
FROM `oc_session`
WHERE session_id = '6ed7253f1e4fd8ba0cead8e0a3'

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (821.662)

CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%50%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737

4 (1.243)

SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t

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

5 (83.833)

SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 5860, 20

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

6 (12.671)

SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248

7 (0.091)

SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270

8 (2.645)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035

9 (159.255)

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949

10 (0.127)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produse ce potrivesc criteriilor de căutare

CARLIGE LEGATE DAIWA TOURNAMENT PT.CRAP NR.6/10BUC

CARLIGE COLMIC NUCLEAR BS5000 NR 18

Lanseta Maver BOLOGNEZA SUPERLITIUM EVO GREEN POWER MX 5M Inele Fuji Torzite

SHAD DAIWA D.FIN 10CM GREEN PEARL/7BUC

Nada Benzar Mix Special Platica 1kg

Vobler Salmo Tiny 3,0cm/2,5g Sinking IT3S CC

FIR COLMIC PROJECT 360 NX30 100M 0.50mm

FIR JAXON CARAT SPINNING 150m 0.45mm 30.00 kg

Pelete Bait Tech Carp & Coarse, 4mm, 700g

Carlig Owner Cp 50674 Argintiu Patrat Nr 8 - 15buc/pac

Momitor Feeder Rotund 50Gr

ADITIV LICHID BENZAR MIX SPICE 500ML

Benzar Mix Jelly Bait Rama 10buc

FIR MONOFILAMENT TRABUCCO TF XPS SINKING PLUS 150MT 0.20MM

MULINETA SAVAGE GEAR SG4 4000 FD 8+1BB/150M/028MM/5,2:1/

Carlig Owner 50404 Auriu Rotund Tija Scurta Nr 1 - 5buc/plic

CUPA COLMIC DE NADIT DUBLA 250ml

FIR COLMIC METHOD FEEDER 250M 0.30mm

Juvelnic Nevis Concurs 2.50m

Waders DAM Hydroforce Nylon Taslan Chestwader 44

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare