Căutare

Queries: 11, Total time: 964.140 ms [By time] [By id] [By file]

1 (0.171)

SELECT data
FROM `oc_session`
WHERE session_id = 'f9ee55c7245c2bed5c1b1fd794'

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

2 (0.114)

SELECT `trigger`, `action`
FROM oc_event

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

3 (708.968)

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 "%20%") 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.317)

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

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

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

6 (0.144)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'

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

7 (13.735)

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

8 (0.154)

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

9 (2.946)

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

10 (159.253)

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

11 (0.136)

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

Pelete Flotante CPK Feeder Glow in the Dark, Capsuna, 14/16mm

Piatra Pallatrax In-line Stonze, Medium, 40g, 1buc/plic

Piatra Pallatrax In-line Stonze, Mic, 60g, 1buc/plic

Pichet Trakker Quickstick 36 Inch, 90cm

Pichet Trakker Specialist Storm Pole 42-82 Inch, 107-200cm

Plumb Cu Vartej Nevis, 20g

Plumb Zfish Back Lead QL 20g, 2buc/pac

Plumbi Spro Cresta Coated Inline Olivettes, 1.2g, 6buc/plic

Plumbi Spro Cresta Coated Inline Olivettes, 5.0g, 4buc/plic

Pop Up 2.20 Baits Supreme, Alb - Portocaliu, Bellachan & Capsuna, 16mm, 100ml

Pop Up 2.20 Baits Supreme, Galben- Portocaliu, Squid & Portocala, 16mm, 100ml

Pop Up Delphin D Snax, Porumb & Ananas, 10mm, 20g

Pop Up Fluor Pro Line, Bubblegum, 12mm, 200ml

Pop Up Nash Citruz New, Natural, 20mm, 75g

Pop Up Nash Citruz New, White, 20mm, 75g

Pop Up Senzor Planet, Ananas, 12mm, 30g

Pungi Solubile DAM Madcat 25x10cm, 20buc/pac

Rig Crap Blowback 06 Orange Series 9 No.4, 20lb, 3buc/pac

Rig Crap Ronnie Rig 08 Orange Series 7 No.8, 20lb, 3buc/pac

Rig Feeder Owner 56935 No.10 0.15 FDB-01 Spear Braided, 6buc/pac

Produsul a fost adăugat în coș

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

Căutare

Produse ce potrivesc criteriilor de căutare