Căutare

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

1 (0.144)

SELECT data
FROM `oc_session`
WHERE session_id = '77f5fa3023ef60a37220ca5c28'

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

2 (0.119)

SELECT `trigger`, `action`
FROM oc_event

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

3 (717.556)

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.389)

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 (72.424)

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 4780, 20

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

6 (12.622)

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.125)

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.758)

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 (193.240)

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.126)

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

CRACAN JAXON JAXON TELE 80-150CM

Motor Minn Kota Electric New Traxxis 55 lbs 12v

Mulineta Colmic VRZ FD 3500

VARF CORMORAN PT.FEEDER PRO RED 3,05OZ

LANTERNA CAP LED LENSER MH11 BLACK BLUETOTH 1000LM CU ACUMULATOR SI USB

FIR DAIWA J-BRAID X8 MULTICOLOR 013MM/8KG/150M

FIR COLMIC OMEGA PT50 300M 0.30mm Galben Fluo

FIR MAVER SMART MRT 2.0 150M 0.148MM

CORT TIP UMBRELA CU PLASA ANTI TANTAR 250CM JAXON

Carlig Owner 50010 Negru Patrat cu Spin Nr 1/0 - 8buc/plic

FIR DAIWA J-BRAID X8 MULTICOLOR 010MM/6KG/150M

Benzar Jelly Baits Baby Worm Galben

Carlig Owner 50921 Crom Tija Lunga Anou Nr 14 - 11buc/plic

FIR CARP ZOOM LEADER FEEDER COMPETITION 0.22mm 6.5kg 50m TRANSPARENT

FIR JAXON TEXTIL SUMATO CATFISH 1000m 0.50mm

Cap Minciog Crap Feeder Match Extra Carp Floating 60x50cm

Fir Monofilament 1.40mm/50m

Stopper Boilies Ciupercuta Carp Spirit DIVERSE CULORI (50 buc)

LANSETA COLMIC MALIB TELEBOAT 2.70M, 50-150G, 5SEG

PB CONTROL MONO 0,30/1250M

Produsul a fost adăugat în coș

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

Căutare

Produse ce potrivesc criteriilor de căutare